package com.example.spinning.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.spinning.bean.EndProductQuality;

import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface EndQualityMapper extends BaseMapper<EndProductQuality> {

    //添加一条新的原料记录
    int addNewEndQuality(EndProductQuality endProductQuality);

    //根据id删除原料记录
    int deleteEndQualityById(@Param("ids") Long[] ids);

    //根据id查记录
    EndProductQuality getEndQualityById(Long id);

    //根据品名查记录
    List<EndProductQuality> getEndQualityByName(@Param("name") String name);
    //查指定品名的数量
    int getNameCount(@Param("name") String name);

    //按日期查找

    //按品名和日期查找

    //修改
    int updateEndQualityById(EndProductQuality endProductQuality);
    //查所有
    List<EndProductQuality> getAll(@Param("start") Integer start, @Param("count") Integer count);
    //查总数量
    int getAllCount();

}



